﻿CREATE TABLE [dbo].[InventoryItemByVendorMMC] (
    [InventoryItemByVendor] BIGINT         IDENTITY (1, 1) NOT NULL,
    [InventoryItemID]       INT            NOT NULL,
    [LocationID]            INT            NOT NULL,
    [vendorID]              SMALLINT       NOT NULL,
    [priceTable]            INT            NULL,
    [priceSingle]           DECIMAL (5, 2) NULL,
    [costTable]             INT            NULL,
    [costSingle]            DECIMAL (5, 2) NULL,
    [dateadded]             DATETIME       NOT NULL,
    [isActive]              BIT            NOT NULL,
    [userAddedID]           INT            NOT NULL,
    [isDeleted]             BIT            NOT NULL
);



